﻿CREATE TABLE [flcr].[PROJECT_BOOKING_TYPE] (
    [PROJ_BOOKING_TYPE_ID] INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]           VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]           DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]        INT           NOT NULL,
    [AUDIT_MOD_USER]       VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]       DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]    INT           NOT NULL,
    [BUILTIN]              BIT           NOT NULL,
    [ACTIVE_FLG]           BIT           NOT NULL,
    [SORT_ORDER]           INT           NOT NULL,
    [BOOKING_TYPE]         INT           NOT NULL,
    [BOOKING_TYPE_NAME]    VARCHAR (100) NOT NULL,
    [BOOKING_TYPE_DESC]    VARCHAR (250) NOT NULL,
    [BOOKING_TYPE_GROUP]   INT           NOT NULL,
    [PARENT_ID]            INT           NULL
);

